IF EXISTS (SELECT name FROM sysobjects WHERE name = 'IHIOActivityHistory')
Truncate Table dbo.IHIOActivityHistory;

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'InsuranceOrganization')
Truncate table dbo.InsuranceOrganization;

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'DrugPrices')
Truncate Table dbo.DrugPrices;


IF EXISTS
(
    SELECT 1
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[EPOCheckValidateOrderId]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[EPOCheckValidateOrderId];


IF EXISTS
(
    SELECT 1
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[AddTaminPrescription]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[AddTaminPrescription];


IF EXISTS
(
    SELECT 1
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[MakeAutoReturnPrescription]')
          AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
    DROP PROCEDURE [dbo].[MakeAutoReturnPrescription];



